 Exec USP_IVR_ITEM_ISSUE 471415,'2014/08/22','SUPER  ADMINISTRATOR','2014/08/26','SUPER  ADMINISTRATOR','Navdeep Kumar','admin@digitalsolutions.co.in'; 
 Declare @IssueID int set @IssueID=(SELECT IDENT_CURRENT('IVR_ISSUEITEM') AS IssueID); 
 Declare @IssueDetailID int; Declare @IssueBatchID int; 
 EXEC USP_IVR_ISSUEITEM_DETAILS  @IssueID ,155,2016,'ESIC000834','IC REG CTRLR BST FLYBK PWM 8SOIC','sdfsdf',57,20,23,23,'admin@digitalsolutions.co.in';
 set @IssueDetailID=(SELECT IDENT_CURRENT('IVR_ISSUEITEM_DETAILS') AS IssueDetailID); 
 Exec USP_IVR_ISSUEITEM_BATCHDETAILS @IssueDetailID ,3451,2016,23,55.6316483516483,'2014/04/01',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1279.52791208791,'admin@digitalsolutions.co.in',null,'OP',null,null,null,null,null,null,null,null,null; 
 set @IssueBatchID=(SELECT IDENT_CURRENT('IVR_ISSUEITEM_BATCHDETAILS') AS IssueBatchID); 
 EXEC USP_IVR_COMMONITEM_ISSUERETURN 3451,@IssueID,@IssueDetailID,@IssueBatchID,null,null,null,2016,23,55.6316483516483,'2014/04/01',null,null,null,null,null,null,null,null,null,null,null,null,1279.52791208791,'ISSUE','471415',155,23,1279.52791208791,'2014/08/26',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null; 
 Update IVR_ITEMOPENBAL set ISSUEQTY=ISSUEQTY + 23 where SLNUM=3451; 
 update IVR_OnlineRegistration_Detail 
 set IssueQty=ISNULL(IssueQty,0) +'23',IssuedDate='2014-08-26',ITMID=2016 where Id='1495';
 
 
ALTER TABLE IVR_OnlineRegistrationSlip ADD CONSTRAINT UQ_SlipNo UNIQUE (slipno)